Regular Expression Validators

When a user provides values to be used in criteria, you may validate the values provided in a number of ways. One of those ways involves using regular expressions.

SQL Designer comes with a number of common regular expressions provided for common data types and the Regular Expressions Dialog provides you with a simple method of managing these and adding additional regular expressions for data entry validation to the Global Settings document. You may launch the Regular Expressions Dialog from the global Settings menu item of the Schema Editor.

Additionally, the Expression link on the dialog window is a browser link to www.regexlib.com which is a very valuable resource as a regular expression library of expressions developed by the developer community.  (Note: Connect4 has no relationship with the providers of this web site and this link is provided only as a convenience).

Once regular expressions have been entered to global settings, they will be available for assignment as a Field Input Validator by selecting them via the Field Editor Property in the field properties area of schema design.